package com.auxgroup.hr.front.dao.repository;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.auxgroup.hr.front.dao.domain.PsCWfOvrtHdr;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCWfOvrtHdrRepository extends
JpaRepository<PsCWfOvrtHdr,String>,JpaSpecificationExecutor<PsCWfOvrtHdr> {
	
 	@Modifying
 	@Transactional
    @Query(value = "delete from PsCWfOvrtHdr where cTransactionNbr=:transNum")
    public Integer deleteByTransNum(@Param("transNum") String transNum);
}